1 GLOSSARY

1.1 SKU Classification

SKU A: SKUs accumlating up to 80% of analyzing period’s NMV

SKU B: SKUs accumlating up to 95% of analyzing period’s NMV

SKU C: SKUs accumlating up to 100% of analyzing period’s NMV

SKU D: SKU contributing no sales in the analyzing period’s NMV

1.2 SKU Attributes

Active SKUs wihin a period is any SKU which:

  • Has available stock

  • Generates sales

  • Has shrinkage.

New SKUs are SKUs on-boarded within 30 days from the reported date.

2 OVERVIEW FOR TOTAL NGON

2.1 Margins

Front Margin will be calculated based on the following formular:

\[\begin{eqnarray} FrontMargin &=& \frac{ProductSellingValue - ProductBuyingValue}{ProductSellingValue} \\\\ &=& \frac{\sum{SellingPrice*Qty} - \sum{COGS*Qty}}{\sum{SellingPrice*Qty}} \end{eqnarray}\]

2.1.1 Month To Date - Margin - Total Ngon Sub-category

Margins are calculated based on sales and inventory data from 2022-11-01 to 2022-11-29

2.1.2 Last Month - Margin - Total Ngon Sub-category

Margins are calculated based on sales and inventory data from 2022-10-01 to 2022-11-01

2.2 Out-of-Stock Analysis

2.2.1 Methodology

Average Daily Sales: \[AverageDailySales = \frac{TotalNMV}{ActiveDays}\]

Out of Stock Rate: \[OOS Rate = \frac{\sum(AverageDailySales*OOSDays)}{\sum(AverageDailySales*ReviewPeriodDays)}\]

  • OOS Rate describes the NMV opportunity lost due to OOS dates within review period

2.2.2 OOS Rate by Ngon Sub Cate

2.3 Shrinkage Analysis

Last 7-day shrinkage value

From 2022-11-20 to 2022-11-26

\[\text{SHRINKAGE ABSOLUTE VALUE (VND) BY WAREHOUSE}\]

\[\text{SHRINKAGE PERCENTAGE BY WAREHOUSE}\]

3 OVERVIEW FOR NORTH

As of 2022-11-29, sub-category FRESH has 824 salable products.

The products within each category are as followed:

For FRESH, the number of SKU per warehouse is as followed:

4 LAST 30 DAYS REVIEW

The SKUs being reviewed in this period are (1) SKUs having available stock, (2) SKUs generating sales and (3) SKUs having shrinkage.

Review period: MidTerm

Review region: NORTH

Review Cate Report: FRESH

From: 2022-10-30

To: 2022-11-29

As of 2022-11-29, sub-category FRESH has 824 salable products.

Total SKU Active in this period: 261

4.1 Top Performing SKUs

There are 44 products contribute to 80% of this period’s NMV.

Top 10 SKU with the best NMV contributions are as followed:

4.2 Selection Health

4.2.1 Segmentation by Positive RFM and 2% NMV Contribution

4.3 Keywords Analysis

Top 100 Keywords - Total Tiki/Affiliated Channel Directed from all sources

Top 100 Keywords - Ngon Hub Only from TikiNgon page

5 EXPORTING DATA

For more information, please review the file raw_data_FRESH_NORTH.xlsx in the shared folder. Thank you!